IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[InsertBanco]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
	DROP PROCEDURE [dbo].[InsertBanco]
GO

CREATE PROCEDURE [dbo].[InsertBanco]
(
	@IdBanco int OUT,
	@Nombre varchar(155),
	@Descripcion varchar(255)
)
AS
BEGIN
	SET NOCOUNT ON

	INSERT INTO [Banco] ([Nombre], [Descripcion]) 
	VALUES (@Nombre, @Descripcion)

	SET @IdBanco = SCOPE_IDENTITY()

	SET NOCOUNT OFF
END

GO
